﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PassportManageDataSet" targetNamespace="http://tempuri.org/PassportManageDataSet.xsd" xmlns:mstns="http://tempuri.org/PassportManageDataSet.xsd" xmlns="http://tempuri.org/PassportManageDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="PassportManageConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PassportManageConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DAL.Properties.Settings.GlobalReference.Default.PassportManageConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PassportInfoTableAdapter" GeneratorDataComponentClassName="PassportInfoTableAdapter" Name="PassportInfo" UserDataComponentName="PassportInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, AddTime, Operator FROM dbo.PassportInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TaskCode" DataSetColumn="TaskCode" />
              <Mapping SourceColumn="CardCode" DataSetColumn="CardCode" />
              <Mapping SourceColumn="Birthday" DataSetColumn="Birthday" />
              <Mapping SourceColumn="CardID" DataSetColumn="CardID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="OprationNumber" DataSetColumn="OprationNumber" />
              <Mapping SourceColumn="Pillar" DataSetColumn="Pillar" />
              <Mapping SourceColumn="Layer" DataSetColumn="Layer" />
              <Mapping SourceColumn="Cell" DataSetColumn="Cell" />
              <Mapping SourceColumn="AddTime" DataSetColumn="AddTime" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByTaskCode" Modifier="Public" Name="DeleteByTaskCode" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteByTaskCode">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM PassportInfo
WHERE (TaskCode = @TaskCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskCode" ColumnName="TaskCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@TaskCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="TaskCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCardCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCardCode" GeneratorSourceName="FillByCardCode" GetMethodModifier="Public" GetMethodName="GetDataByCardCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCardCode" UserSourceName="FillByCardCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (CardCode LIKE '%' + @CardCode + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CardCode" ColumnName="CardCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CardCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CardCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCardID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCardID" GeneratorSourceName="FillByCardID" GetMethodModifier="Public" GetMethodName="GetDataByCardID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCardID" UserSourceName="FillByCardID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (CardID LIKE '%' + @CardID + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CardID" ColumnName="CardID" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CardID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLayer" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLayer" GeneratorSourceName="FillByLayer" GetMethodModifier="Public" GetMethodName="GetDataByLayer" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLayer" UserSourceName="FillByLayer">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (Pillar = @Pillar) AND (Layer = @Layer)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Pillar" ColumnName="Pillar" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Pillar" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Pillar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Layer" ColumnName="Layer" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Layer" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Layer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLikeTaskCode" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLikeTaskCode" GeneratorSourceName="FillByLikeTaskCode" GetMethodModifier="Public" GetMethodName="GetDataByLikeTaskCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLikeTaskCode" UserSourceName="FillByLikeTaskCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (TaskCode LIKE '%' + @TaskCode + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskCode" ColumnName="TaskCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@TaskCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="TaskCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (Name LIKE '%' + @Name + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByOprationNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByOprationNumber" GeneratorSourceName="FillByOprationNumber" GetMethodModifier="Public" GetMethodName="GetDataByOprationNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByOprationNumber" UserSourceName="FillByOprationNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (OprationNumber LIKE '%' + @OprationNumber + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="OprationNumber" ColumnName="OprationNumber" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@OprationNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="OprationNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPillar" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPillar" GeneratorSourceName="FillByPillar" GetMethodModifier="Public" GetMethodName="GetDataByPillar" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPillar" UserSourceName="FillByPillar">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (Pillar = @Pillar)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Pillar" ColumnName="Pillar" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Pillar" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Pillar" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPosition" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPosition" GeneratorSourceName="FillByPosition" GetMethodModifier="Public" GetMethodName="GetDataByPosition" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPosition" UserSourceName="FillByPosition">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (Pillar = @Pillar) AND (Layer = @Layer) AND (Cell = @Cell)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Pillar" ColumnName="Pillar" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Pillar" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Pillar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Layer" ColumnName="Layer" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Layer" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Layer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cell" ColumnName="Cell" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Cell" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.PassportInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTaskCode" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataByTaskCode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTaskCode" UserSourceName="GetDataByTaskCode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, 
      AddTime, Operator
FROM PassportInfo
WHERE (TaskCode = @TaskCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskCode" ColumnName="TaskCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@TaskCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="TaskCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[PassportInfo] ([TaskCode], [CardCode], [Birthday], [CardID], [Name], [OprationNumber], [Pillar], [Layer], [Cell], [AddTime], [Operator]) VALUES (@TaskCode, @CardCode, @Birthday, @CardID, @Name, @OprationNumber, @Pillar, @Layer, @Cell, @AddTime, @Operator);
SELECT TaskCode, CardCode, Birthday, CardID, Name, OprationNumber, Pillar, Layer, Cell, AddTime, Operator FROM PassportInfo WHERE (TaskCode = @TaskCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskCode" ColumnName="TaskCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@TaskCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="TaskCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CardCode" ColumnName="CardCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CardCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CardCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Birthday" ColumnName="Birthday" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Birthday" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="Birthday" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CardID" ColumnName="CardID" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CardID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="OprationNumber" ColumnName="OprationNumber" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@OprationNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="OprationNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Pillar" ColumnName="Pillar" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Pillar" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Pillar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Layer" ColumnName="Layer" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Layer" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Layer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cell" ColumnName="Cell" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Cell" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AddTime" ColumnName="AddTime" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@AddTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE PassportInfo
SET CardCode = @CardCode, Birthday = @Birthday, CardID = @CardID, Name = @Name, 
      OprationNumber = @OprationNumber, Pillar = @Pillar, Layer = @Layer, Cell = @Cell, 
      AddTime = @AddTime, Operator = @Operator
WHERE (TaskCode = @TaskCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CardCode" ColumnName="CardCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CardCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CardCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Birthday" ColumnName="Birthday" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@Birthday" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="Birthday" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CardID" ColumnName="CardID" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CardID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="OprationNumber" ColumnName="OprationNumber" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@OprationNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="OprationNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Pillar" ColumnName="Pillar" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Pillar" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Pillar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Layer" ColumnName="Layer" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Layer" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Layer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cell" ColumnName="Cell" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Cell" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Cell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AddTime" ColumnName="AddTime" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@AddTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskCode" ColumnName="TaskCode" DataSourceName="PassportManage.dbo.PassportInfo" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@TaskCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="TaskCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SystemLogTableAdapter" GeneratorDataComponentClassName="SystemLogTableAdapter" Name="SystemLog" UserDataComponentName="SystemLogTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.SystemLog" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill_GetSave" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData_GetSave" GeneratorSourceName="Fill_GetSave" GetMethodModifier="Public" GetMethodName="GetData_GetSave" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData_GetSave" UserSourceName="Fill_GetSave">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   ID, LogContent, LogType, LogRemark, Operator, AddTime
FROM      SystemLog
WHERE   (LogType = '护照存取') AND (LogRemark = '新增') AND (AddTime BETWEEN @start AND @end) OR
                (LogType = '护照存取') AND (LogRemark = '自动更改位置') AND (AddTime BETWEEN @start AND @end)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="start" ColumnName="AddTime" DataSourceName="PassportManage.dbo.SystemLog" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@start" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="end" ColumnName="AddTime" DataSourceName="PassportManage.dbo.SystemLog" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@end" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="LogContent" DataSetColumn="LogContent" />
              <Mapping SourceColumn="LogType" DataSetColumn="LogType" />
              <Mapping SourceColumn="LogRemark" DataSetColumn="LogRemark" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="AddTime" DataSetColumn="AddTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PassportManageConnectionString (Settings)" DbObjectName="PassportManage.dbo.SystemLog" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill_GetOut" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData_GetOut" GeneratorSourceName="Fill_GetOut" GetMethodModifier="Public" GetMethodName="GetData_GetOut" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData_GetOut" UserSourceName="Fill_GetOut">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   AddTime, ID, LogContent, LogRemark, LogType, Operator
FROM      SystemLog
WHERE   (LogType = '护照存取') AND (LogRemark = '护照取出') AND (AddTime BETWEEN @start AND @end)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="start" ColumnName="AddTime" DataSourceName="PassportManage.dbo.SystemLog" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@start" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="end" ColumnName="AddTime" DataSourceName="PassportManage.dbo.SystemLog" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@end" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PassportManageDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="PassportManageDataSet" msprop:Generator_DataSetName="PassportManageDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PassportInfo" msprop:Generator_UserTableName="PassportInfo" msprop:Generator_RowDeletedName="PassportInfoRowDeleted" msprop:Generator_RowChangedName="PassportInfoRowChanged" msprop:Generator_RowClassName="PassportInfoRow" msprop:Generator_RowChangingName="PassportInfoRowChanging" msprop:Generator_RowEvArgName="PassportInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="PassportInfoRowChangeEventHandler" msprop:Generator_TableClassName="PassportInfoDataTable" msprop:Generator_TableVarName="tablePassportInfo" msprop:Generator_RowDeletingName="PassportInfoRowDeleting" msprop:Generator_TablePropName="PassportInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TaskCode" msprop:Generator_UserColumnName="TaskCode" msprop:Generator_ColumnVarNameInTable="columnTaskCode" msprop:Generator_ColumnPropNameInRow="TaskCode" msprop:Generator_ColumnPropNameInTable="TaskCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CardCode" msprop:Generator_UserColumnName="CardCode" msprop:Generator_ColumnVarNameInTable="columnCardCode" msprop:Generator_ColumnPropNameInRow="CardCode" msprop:Generator_ColumnPropNameInTable="CardCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Birthday" msprop:Generator_UserColumnName="Birthday" msprop:Generator_ColumnVarNameInTable="columnBirthday" msprop:Generator_ColumnPropNameInRow="Birthday" msprop:Generator_ColumnPropNameInTable="BirthdayColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CardID" msprop:Generator_UserColumnName="CardID" msprop:Generator_ColumnVarNameInTable="columnCardID" msprop:Generator_ColumnPropNameInRow="CardID" msprop:Generator_ColumnPropNameInTable="CardIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OprationNumber" msprop:Generator_UserColumnName="OprationNumber" msprop:Generator_ColumnVarNameInTable="columnOprationNumber" msprop:Generator_ColumnPropNameInRow="OprationNumber" msprop:Generator_ColumnPropNameInTable="OprationNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pillar" msprop:Generator_UserColumnName="Pillar" msprop:Generator_ColumnVarNameInTable="columnPillar" msprop:Generator_ColumnPropNameInRow="Pillar" msprop:Generator_ColumnPropNameInTable="PillarColumn" type="xs:int" />
              <xs:element name="Layer" msprop:Generator_UserColumnName="Layer" msprop:Generator_ColumnVarNameInTable="columnLayer" msprop:Generator_ColumnPropNameInRow="Layer" msprop:Generator_ColumnPropNameInTable="LayerColumn" type="xs:int" />
              <xs:element name="Cell" msprop:Generator_UserColumnName="Cell" msprop:Generator_ColumnVarNameInTable="columnCell" msprop:Generator_ColumnPropNameInRow="Cell" msprop:Generator_ColumnPropNameInTable="CellColumn" type="xs:int" />
              <xs:element name="AddTime" msprop:Generator_UserColumnName="AddTime" msprop:Generator_ColumnVarNameInTable="columnAddTime" msprop:Generator_ColumnPropNameInRow="AddTime" msprop:Generator_ColumnPropNameInTable="AddTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SystemLog" msprop:Generator_UserTableName="SystemLog" msprop:Generator_RowDeletedName="SystemLogRowDeleted" msprop:Generator_TableClassName="SystemLogDataTable" msprop:Generator_RowChangedName="SystemLogRowChanged" msprop:Generator_RowClassName="SystemLogRow" msprop:Generator_RowChangingName="SystemLogRowChanging" msprop:Generator_RowEvArgName="SystemLogRowChangeEvent" msprop:Generator_RowEvHandlerName="SystemLogRowChangeEventHandler" msprop:Generator_TablePropName="SystemLog" msprop:Generator_TableVarName="tableSystemLog" msprop:Generator_RowDeletingName="SystemLogRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="LogContent" msprop:Generator_UserColumnName="LogContent" msprop:Generator_ColumnPropNameInRow="LogContent" msprop:Generator_ColumnVarNameInTable="columnLogContent" msprop:Generator_ColumnPropNameInTable="LogContentColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LogType" msprop:Generator_UserColumnName="LogType" msprop:Generator_ColumnPropNameInRow="LogType" msprop:Generator_ColumnVarNameInTable="columnLogType" msprop:Generator_ColumnPropNameInTable="LogTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LogRemark" msprop:Generator_UserColumnName="LogRemark" msprop:Generator_ColumnPropNameInRow="LogRemark" msprop:Generator_ColumnVarNameInTable="columnLogRemark" msprop:Generator_ColumnPropNameInTable="LogRemarkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddTime" msprop:Generator_UserColumnName="AddTime" msprop:Generator_ColumnPropNameInRow="AddTime" msprop:Generator_ColumnVarNameInTable="columnAddTime" msprop:Generator_ColumnPropNameInTable="AddTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PassportInfo" />
      <xs:field xpath="mstns:TaskCode" />
    </xs:unique>
    <xs:unique name="SystemLog_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SystemLog" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>